package cn.com.api.mapper.base;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiT_member_task_process;

//DAO
public interface T_member_task_processMapperBase {

	// 根据id查看
	@Select("SELECT * FROM T_MEMBER_TASK_PROCESS  WHERE PROCESS_ID = #{process_id}")
	public ApiT_member_task_process findT_member_task_processById(Integer process_id);

	// 查看数据集
	@Select("SELECT * FROM T_member_task_process")
	public List<ApiT_member_task_process> findT_member_task_processs();

	// 根据条件查看数据集
	public List<Map<String, Object>> findT_member_task_processsByMap(HashMap condition);

	// 添加
	// @Insert("INSERT INTO T_MEMBER_TASK_PROCESS (PROCESS_ID, USER_ID, TASK_ID,
	// DEAD_TIME, CURR_PARTNER_COUNT, CURR_ENT_COUNT, CURR_ADVERT_MONEY,
	// FROZEN_MONEY) VALUES (SEQT_MEMBER_TASK_PROCESS_ID.nextVal, #{user_id},
	// #{task_id}, #{dead_time}, #{curr_partner_count}, #{curr_ent_count},
	// #{curr_advert_money}, #{frozen_money})")
	// @Options(useGeneratedKeys = false, keyProperty = "process_id")
	public int insertT_member_task_process(ApiT_member_task_process t_member_task_process);

	// 修改
	@Update("UPDATE T_MEMBER_TASK_PROCESS SET USER_ID = #{user_id},task_is_finish=#{task_is_finish}, TASK_ID = #{task_id}, DEAD_TIME = #{dead_time}, CURR_PARTNER_COUNT = #{curr_partner_count}, CURR_ENT_COUNT = #{curr_ent_count}, CURR_ADVERT_MONEY = #{curr_advert_money}, FROZEN_MONEY = #{frozen_money} WHERE PROCESS_ID = #{process_id}")
	public int updateT_member_task_process(ApiT_member_task_process t_member_task_process);

	// 删除
	@Delete("DELETE FROM T_MEMBER_TASK_PROCESS  WHERE PROCESS_ID = #{process_id}")
	public int deleteT_member_task_process(Integer process_id);

	// Foreign keys revelant

	// region Indexs revelant

}
